	
/****** Object:  Stored Procedure ConPointsUpdate    Script Date: Tuesday, October 16, 2007 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spConPointsUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spConPointsUpdate]
GO

	
	

	
/******************************************************************************
**		File: 
**		Name: spConPointsUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 10/16/2007 5:29:51 PM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spConPointsUpdate
	@ConPointID int, 
	@Description nvarchar(50), 
	@Goods nvarchar(500), 
	@IsDisplayed bit, 
	@ContainerLoading nvarchar(500), 
	@LoadingPort nvarchar(200) 
AS

UPDATE [ConPoints] SET
	[Description] = @Description,
	[Goods] = @Goods,
	[IsDisplayed] = @IsDisplayed,
	[ContainerLoading] = @ContainerLoading,
	[LoadingPort] = @LoadingPort
WHERE
	[ConPointID] = @ConPointID

GO
